SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This stunning residence perfectly blends sophistication and convenience, located just moments from Eastmans South Cove Activity Center. The residence combines comfort and style to create the ultimate retreat situated on over 2 private acres. The spacious living area features hardwood floors, cozy fireplace, soaring ceiling and large windows that flood the space with natural light. Enjoy a book or your morning coffee in the three season porch area offering views of the backyard oasis. The main level also features a beautiful chef's kitchen with custom cabinetry that flows to the dining area with another fireplace. Highlights of this home also boasts a library, den, morning bar area, large laundry room and first floor primary bedroom with a spacious bathroom. The upper level features another primary bedroom with a generous bathroom, guest bedroom en suite and a crafts room. Outside you will find above the two car detached garage a in-law suite or additional guest space with a bedroom, kitchen and a living area. Another two car garage area also has a beautiful spacious office or recreation area. This exceptional property is not to be missed.
Description:2 WOODS END ROAD- Well maintained 3-bed & 4-bath contemporary sited on 3 landscaped acres conveniently located just 10 minutes from downtown Hanover. A spacious and updated kitchen flows effortlessly into an open concept living & dining area with fireplace and wood stove and an expansive outdoor deck and gazebo, all of which bathes in natural light to make it a perfect setup for entertaining family and friends. On the front side of the house is another sizable living or family area, office space that is a ground floor bedroom option, and 3/4 bath. The second floor features a warm and sunlit primary suite, two additional bedrooms, and a full bath. A finished lower level complete with full bath and two versatile recreation / bonus rooms offers plenty of overflow space. Renovated mudroom on main level is dog kennel option. With easy access to area schools, recreation, restaurants, shopping, and more, this turnkey Hanover home is a must-see. Most of furnished photos are virtually staged.